

GetOneRebotItem="""SELECT
id,
remark,
lable_image_name,
lable_image_num,
lable_size_wight,
lable_size_height,
lable_move_x,
lable_move_y 
FROM %s.REBOT_ACTION A 
WHERE A.command_id='%s'"""

GetOneUrlMethodItem="""SELECT
id,
url,
method 
FROM %s.REQUESTS_URL A 
WHERE A.command_id='%s'"""

GetOnePrameItem="""SELECT
id,
request_key,
request_value 
FROM %s.PARAME_DATE A 
WHERE A.command_id='%s'"""

GetOneSmallItem="""SELECT
id,
remark,
lable_two_image_name,
lable_two_image_num,
lable_two_image_wight,
lable_two_image_height,
lable_two_move_x,
lable_two_move_y 
FROM %s.SMALL_IMAGE A 
WHERE A.command_id='%s'"""

GetOneTxtItem="""SELECT
id,
remark,
txt_brow_name,
txt_brow_num,
txt_brow_wight,
txt_brow_height,
txt_brow_move_x,
txt_brow_move_y 
FROM %s.TXT_SIZE A 
WHERE A.command_id='%s'"""

GetOneQssTxtItem="""SELECT
id,
font_size,
padding_top,
padding_bottom,
padding_left,
padding_right 
FROM %s.TXT_QSS_ A 
WHERE A.txt_id='%s'"""


GetOneSeleniumTxtItem="""SELECT
id,
ORDER_GROUP_NAME 
FROM %s.S_ORDER_GROUP A 
WHERE A.command_id='%s'"""

GetOneSonNiumTxtItem="""SELECT
id,
FIND_ELEMENT_TYPE,
FIND_VALUE,
OP_TYPE,
OP_VALUE,
operation_type,
REMARK 
FROM %s.S_ORDER A 
WHERE A.ORDER_GROUP_ID='%s' 
order by A.EXECUTE_ORDER"""


DemoGetInstructionsIntface ="""SELECT 
id,
a_interface,
where_method,
is_main,
by_main_id,
return_parame,
instruc_order,
instruc_Time,
remark
FROM %s.INSTRUCTION A 
WHERE A.BY_MAIN_ID='%s' AND A.is_main!=1 AND (A.return_parame IN %s) 
order by A.INSTRUC_ORDER"""

DemoGetInstructionsOne ="""SELECT 
id,
a_interface,
where_method,
is_main,
by_main_id,
return_parame,
instruc_order,
instruc_Time,
remark 
FROM %s.INSTRUCTION A 
WHERE A.BY_MAIN_ID='%s' AND A.is_main!=1 AND A.return_parame='%s'  
order by A.INSTRUC_ORDER"""



DemoGetMainInstructionsIntface ="""SELECT 
id,
a_interface,
where_method,
is_main,
by_main_id,
return_parame,
instruc_order,
instruc_Time,
remark 
FROM %s.INSTRUCTION A 
WHERE A.BY_MAIN_ID='%s' AND A.is_main=1
"""


GetConfigTxtMsg="""select 
id,
txtorder,
content,
remark 
from %s.TXT_CONFIG 
where command_id='%s' 
order by txtorder 
"""


GetInstructionsList ="""SELECT 
id,
a_interface,
where_method,
return_parame,
instruc_Time,
remark 
FROM %s.INSTRUCTION A 
WHERE A.BY_MAIN_ID='%s' AND A.is_main!=1 
order by A.INSTRUC_ORDER"""